A Diagnostic Approach to Repairing Constraint Violations in Databases
نویسندگان
چکیده
Repairing violations of integrity constraints in databases can be seen as an interleaving diagnostic/repair process. In this paper we introduce a new approach on repairing constraint violations by adopting existing techniques from model–based diagnosis. Violations of integrity constraints observed in an inconsistent database state are diagnosed and repair actions are deduced from diagnoses. By interleaving diagnosing violations and performing repair actions, transactions are computed which restore the consistency of the database.
منابع مشابه
A Diagnostic Approach to Repairing Constraint Violations in Databasesz
Repairing violations of integrity constraints in databases can be seen as an interleaving diagnostic/repair process. In this paper we introduce a new approach on repairing constraint violations by adopting existing techniques from model{based diagnosis. Violations of integrity constraints observed in an inconsistent database state are diagnosed and repair actions are deduced from diagnoses. By ...
متن کاملA Diagnostic Approach to Repairing ConstraintViolations in
Repairing violations of integrity constraints in databases can be seen as an in-terleaving diagnostic/repair process. In this paper we introduce a new approach on repairing constraint violations by adopting existing techniques from model{based diagnosis. Violations of integrity constraints observed in an inconsistent database state are diagnosed and repair actions are deduced from diagnoses. By...
متن کاملSpecifying Reactive Integrity Control for Active Databases
Recent approaches to integrity enforcement in active databases suggest not only to check constraint violations by triggers but also to utilize triggers to perform inconsistency repair actions. However, for sophisticated reactions these approaches often require refinements of already derived integrity maintaining and inconsistency repairing triggers. We argue that analyzing and specifying reacti...
متن کاملOn Specifying the Reactive Behavior on Constraint Violations
Recent approaches to integrity enforcement in active databases suggest not only to check for inconsistencies by triggers but also to utilize triggers to perform repair actions on constraint violations. Typically, respective repairing triggers are derived automatically from constraint specifications following almost fixed derivation strategies. However, in order to incorporate more semantic know...
متن کاملAn Extensible Framework for Repairing Constraint Violations
In this paper we describe a new approach to repairing violations of integrity constraints in databases with null values. By adopting basic concepts from model-based diagnosis, we show how simultaneous reasons for violations of (di erent) constraints can be determined. These reasons, represented as sets of facts, directly indicate possible repair actions that guarantee to remove the observed vio...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 1995